package za.co.chris.traintimes.database;

public class DatabaseConstants {

	public static final String DATABASE_NAME = "trainTimes.db";
	public static final int DATABASE_VERSION = 1;

	public static final String LINE_TABLE = "line";
	public static final String STATION_TABLE = "stations";
	public static final String TIME_TABLE = "times";
	public static final String TRAIN_NO_TABLE = "trainNo";

	public static final String LINE_TABLE_CREATE = "CREATE TABLE " + LINE_TABLE + " (_id integer primary key AUTOINCREMENT, lineName text NOT NULL);";
	public static final String TRAIN_NO_TABLE_CREATE = "CREATE TABLE " + TRAIN_NO_TABLE
			+ " (_id integer primary key AUTOINCREMENT, lineId int NOT NULL, direction int NOT NULL, weekday int NOT NULL, numbers text NOT NULL);";
	public static final String STATION_TABLE_CREATE = "CREATE TABLE " + STATION_TABLE + " (_id integer primary key AUTOINCREMENT, stationName TEXT NOT NULL,lineIds text NOT NULL);";
	public static final String TIMES_TABLE_CREATE = "CREATE TABLE " + TIME_TABLE
			+ " (_id integer primary key AUTOINCREMENT, lineID integer NOT NULL, stationId integer NOT NULL, direction int NOT NULL, days text NOT NULL, times text NOT NULL);";

}
